
alter table jms_dim.dim_lmdm_sys_user_role set tblproperties ('external.table.purge' = 'true');
drop table jms_dim.dim_lmdm_sys_user_role;

CREATE EXTERNAL TABLE jms_dim.dim_lmdm_sys_user_role
(
    id      bigint COMMENT '关联id',
    user_id bigint COMMENT '用户id',
    role_id bigint COMMENT '角色id'
)
    COMMENT '用户-角色-关联表'
    stored as parquet
    LOCATION
        '/dw/hive/jms_dim.db/external/dim_lmdm_sys_user_role'
